package com.whx.managea.dao;

import com.whx.managea.entity.Grade;
import com.whx.managea.entity.Student;
import com.whx.managea.entity.vo.GradeVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import java.util.List;


@Component
@Mapper
public interface GradeDao extends BaseDAO {
    //根据id删除成绩
    void deleteGradeById(Integer id);
    List<GradeVo> findAll(@Param("start") Integer start, @Param("rows") Integer rows, @Param("col") String searchCol, @Param("val") String searchValue);
    GradeVo selectGrade(@Param("stuId") int stuId,@Param("courseName") String courseName);
    //统计学生总数
    Integer counts(@Param("col") String searchCol, @Param("val") String searchValue);
    int  save(Grade grade);
    Integer updateGrade(Grade grade);
}
